create database Mobile_Shop
go 
use Mobile_Shop
go
create table Users(
	user_type varchar(10) ,
	account nvarchar(50)primary key,
	pass nvarchar(50)
)
create table ProductDetails(
	product_code varchar(10)primary key,
	product_name nvarchar(20),
	type_mobile varchar(10),
	price float,
	amount int,
	sup_id varchar(10),
	sup_name nvarchar(50),
	sup_address nvarchar(100),
	sup_phone int
)
go
drop table Product
create table Product(
	product_code varchar(10) primary key,
	product_name nvarchar(20),
	type_mobile varchar(10),
	price float,
	sup_name nvarchar(50)
)
go
create table Supplier(
	sup_id varchar(10)primary key,
	sup_name nvarchar(50),
	sup_address nvarchar(100),
	sup_phone int,
	type_mobile varchar(10),
)
go
create table Customers(
	cus_id int primary key identity(1,1),
	cus_name nvarchar(50),
	cus_address nvarchar(100),
	cus_phone int,
	cus_company_address nvarchar(100)
)
go

create table Orders(
	order_code varchar(10) primary key,
	product_code varchar(10),
	product_name nvarchar(20),
	price float,
	total float,
	cus_id int,
	cus_name nvarchar(50),
	cus_address nvarchar(100),
	cus_phone int,
	emp_id varchar(10),
	emp_name nvarchar(50)
)
go
drop table Employees
create table Employees(
	emp_id varchar(10) primary key,
	emp_name nvarchar(50),
	emp_address nvarchar(100),
	emp_phone int,
	emp_salary float,
	emp_salary_info nvarchar(50),
	emp_date_join date
)
go
drop table Stock
create table Stock(
	stock_id varchar(10)primary key,
	sup_id varchar(10),
	sup_name nvarchar(50),
	product_code varchar(10),
	product_name nvarchar(20),
	stock_price float,
	stock_change float,
	stock_time date
)
go
create table Report(
	
)
